Welcome to this video on Assignment Overview: Data Analysis with SQL. After watching this video, you will be able to Identify the objective of the assignment Describe the tasks in the assignment In this assignment, you will verify and analyze the data structure under the FinPro schema. In this assignment, your first task is to verify the data structure. To complete this task, you will open phpMyadmin to verify the creation of the required six tables within the FinPro schema. Then retrieve a subset of records and check if data is populated in each table using a select query with a limit. Take screenshots of each of the query inputs and outputs. These screenshots should also include the screenshots of the phpMyadmin interface showing the list of tables under the FinPro schema. The second exercise is to conduct a data analysis. You will perform a data analysis by constructing an SQL query that joins multiple tables and calculates the closing balance per bank account. You will also analyze the count of deposits and withdrawals per customer by running the provided SQL query, joining several tables, and aggregating the data. Take screenshots of the SQL queries to perform the analysis and the results of executing this query. You will be expected to include these screenshots in the final presentation that you'll be submitting for peer review. After completing the assignment, you will also complete a checklist to help you check for missed steps. The assignment concludes with a graded quiz that will test your knowledge of aspects of this assignment. In this video, you learned that: In this assignment, you will first verify the data structure. You will open phpMyadmin to verify the creation of the required six tables within the FinPro schema. Then retrieve a subset of records and check if data is populated in each table using a select query with a limit. You will perform SQL queries to analyze the closing balance and count of deposits and withdrawals per customer in the bank.